package com.atguigu.gulimall.product.service.impl;

import org.springframework.stereotype.Service;
import java.util.Map;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.atguigu.common.utils.PageUtils;
import com.atguigu.common.utils.Query;

import com.atguigu.gulimall.product.dao.SkuInfoDao;
import com.atguigu.gulimall.product.entity.SkuInfoEntity;
import com.atguigu.gulimall.product.service.SkuInfoService;
import org.springframework.util.StringUtils;


@Service("skuInfoService")
public class SkuInfoServiceImpl extends ServiceImpl<SkuInfoDao, SkuInfoEntity> implements SkuInfoService {

    @Override
    public PageUtils queryPage(Map<String, Object> params) {
        IPage<SkuInfoEntity> page = this.page(
                new Query<SkuInfoEntity>().getPage(params),
                new QueryWrapper<SkuInfoEntity>()
        );

        return new PageUtils(page);
    }

    @Override
    public PageUtils queryPageByCondition(Map<String, Object> params) {

        QueryWrapper<SkuInfoEntity> wrapper = new QueryWrapper<>();

            // 分类检索
        String catelogId = (String) params.get("catelogId");
          if(!StringUtils.isEmpty(catelogId)&& Integer.parseInt(catelogId)>0){
              wrapper.eq("catalog_id",catelogId);
          }

          // 品牌检索
        String brandId = (String) params.get("brandId");
        if(!StringUtils.isEmpty(brandId)&& Integer.parseInt(brandId)>0){
            wrapper.eq("brand_id",brandId);
        }

            // 价格范围查询
        String min = (String) params.get("min");
        if(!StringUtils.isEmpty(min)&& Integer.parseInt(min)>=0){
            wrapper.ge("price",min);
        }

        String max= (String) params.get("max");
         if(!StringUtils.isEmpty(max)&&Integer.parseInt(max)>Integer.parseInt(min)){
             wrapper.le("price",max);
         }

            // 模糊匹配   有 or查询 就最好用 and方法
        String key = (String) params.get("key");
          if(!StringUtils.isEmpty(key)){
              wrapper.and((w)->
                       w.eq("sku_id",key).or().like("sku_name",key));
          }

        IPage<SkuInfoEntity> page = this.page(
                new Query<SkuInfoEntity>().getPage(params),
                wrapper
        );

        return new PageUtils(page);
    }

}